google.com, pub-8658045329707802, DIRECT, f08c47fec0942fa0
Upwork Test Answers: Get all the correct answers of most recent and possible Upwork Tests A to Z (Updated on Jan, 2016)
Cover Letter Templates: These cover letter samples are not only for Upwork job, but also you will have some idea about your real life job
 
Freelance Profile Overviews: Different Profile samples and overviews of experts, advanced and intermediate level freelancers
For Newbie of Upwork: Upwork Help - How to apply for a job in Upwork with 10 most important articles about Upwork

A to Z View - All Upwork Test Answers

Showing posts with label Upwork Microsoft Excel 2000/2003 test answers. Show all posts
Showing posts with label Upwork Microsoft Excel 2000/2003 test answers. Show all posts

Upwork MS Execl 2000/2003 test answers - 2015

01. What Function does the ‘Compare Side by Side With’ command on the window menu perform?
Ans: It allows you to scroll through two or more workbooks simultaneously
02. Which of the following functions would return a value of 8?
Ans: round(8.4999,0)
03. What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given bellow?
B1:27
B2:22
B3:28
B4:21
Ans: 0
04. How can you select all the blank cells in your worksheet?
Ans: Choose blank in the Edit->Go to->special Menu option
The question is based upon the figure shown
05. The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?
Ans: Its adds up the values in the selected cells
06. You have entered test in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?
Ans: Use the wrap txt option in the Format->Cells>Alignment Menu
07. Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?