1. I select cells Al through A20. How many cells have I selected? a. 19 b. 20 c.
ID: 3878591 • Letter: 1
Question
1. I select cells Al through A20. How many cells have I selected? a. 19 b. 20 c. 21 d. None of them e. All of the above f. None of the above 2. What's an easy way to remove all weekends from a list of dates? a. Use the Weekday layout function d. One at a time b. Right click and select "weekday" e. All of the above c. Delete using the-weekend( ) f. None of the above function 3. Ack! I've frozen the wrong set of cells for the header. What do I do? a. Select any cell and "unfreeze" then d. Select the correct cel freeze the right cells and refreeze b. Use "margins" in Page Layout c. Use the -Unfreeze function e. All of the above f. None of the above 4. I want to multiply the contents of cells B6 and B7 together. What is the formula? d· It can't be done e. All of the above f. None of the above a. B6xB7 c. (86,87) I want to copy a formula to a bunch of cells but I want to keep a cell reference constant. For example, I want to always refer to cell C4. How do I do that? 5. a. $c4 b. c$4 c. $c$4 e. All of the above f. None of the above Suppose the NA V for the first date in your spreadsheet (Cell B3) is $43.12. What is the value in Cell D3? 6. a. $0.00 b. $43.12 C. $(43.12) d. "Undefined" e. All of the above f. None of the above Excel Quiz 1 Page 1Explanation / Answer
Hi,
Ans 1 b)
Total cells that come between A1 to A20 are 20
Ans 2 a)
Weekday() is the function that returns the day number if we pass date as input. It assigns moday as 1 and so on
Ans 3 a)
Wrongly freezed cella need to be unfreezed first. Then, we can freeze the correct cells
Ans 4 b)
* operator is used for the multiplication of values kept in cells
Ans 5 c)
$ symbol is used to tell he compiler that you need to keep a given row or column value as constant
Ans 6 d)
Ans 7 d)
Ans 8 b)
Ans 9 c)
Ans 10 b)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.