MCQs | eBooks – Textbook Solutions All types eBook are available
A. $A$1 B. !A!1 C. #a#1 D. A1 AnswerOption: A
Read More »MS Excel
|
What does the VLOOKUP function do?
A. Finds related records B. Looks up text that contain ‘v’ C. Checks whether text is the same in one cell as in the next D. All of above AnswerOption: C
Read More »You can use drag-and-drop to embed excel worksheet data in a word document
A. By dragging a range of excel data to the word button on the taskbar while pressing Shift key B. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key C. By dragging a range of excel data to the word button on the taskbar while pressing Alt key D. None …
Read More »Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A. OR B. NOT C. IF D. AND AnswerOption: C
Read More »When you insert an Excel file into a Word document, the data are
A. Embedded B. Linked C. Hyperlinked D. Placed in a word table Answer Option: D
Read More »A function inside another function is known as?
A. Switch function B. Nested function C. Sandwich function D. Round function Answer Option: B
Read More »You can activate a cell by?
A. Pressing the Tab key B. Clicking the cell C. Pressing an arrow key D. All of above AnswerOption: D
Read More »VLOOKUP function used to?
A. Finds related records B. Check if two cells are identical C. Looks up text that contain “v” D. None of above Answer Option: A
Read More »To drag a selected range of data to another worksheet in the same workbook, use the?
A. Ctrl key B. Shift key C. Alt key D. Tab key Answer Option: A
Read More »Macros can be executed from which of the following menu?
A. Tools B. Insert C. Home D. Format Answer Option: A
Read More »A typical worksheet has _____ Number of columns
A. 128 B. 256 C. 512 D. 1024 Answer Option: B
Read More »Except which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?
A. NOT B. OR C. IF D. AND Answer Option: C
Read More »To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?
A. Pivot Table List B. Pivot Table Field List C. Pivot Table Report Answer Option: C
Read More »You can convert existing Excel worksheet data and charts to HTML document by using the?
A. Import Wizard B. Intranet Wizard C. Internet Assistant Wizard D. Export Wizard Answer Option: C
Read More »The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row is?
A. C1:10H B. C1:H10 C. C1:H-10 D. C1:H:10 Answer Option: B
Read More »