Ms excel

1. Which setting you must modify to print a worksheet using letterhead? A. Paper B. Margin C. Layout D. Orientation

Paper
Margin
Layout
Orientation

Detailed SolutionWhich setting you must modify to print a worksheet using letterhead? A. Paper B. Margin C. Layout D. Orientation

2. Which would you choose to create a bar diagram? A. Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart

Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart

Detailed SolutionWhich would you choose to create a bar diagram? A. Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart

3. How many worksheets can a workbook have? A. 3 B. 8 C. 255 D. none of above

3
8
255
none of above

Detailed SolutionHow many worksheets can a workbook have? A. 3 B. 8 C. 255 D. none of above

4. Which of the following is not a term of MS-Excel? A. Cells B. Rows C. Columns D. Document

Cells
Rows
Columns
Document

Detailed SolutionWhich of the following is not a term of MS-Excel? A. Cells B. Rows C. Columns D. Document

5. Which language is used to create macros in Excel? A. Visual Basic B. C C. Visual C++ D. Java

Visual Basic
C
Visual C++
Java

Detailed SolutionWhich language is used to create macros in Excel? A. Visual Basic B. C C. Visual C++ D. Java

6. What is the correct way to refer the cell A10 on sheet3 from sheet1? A. Sheet3!A10 B. Sheet1!A10 C. Sheet3.A10 D. A10

Sheet3!A10
Sheet1!A10
Sheet3.A10
A10

Detailed SolutionWhat is the correct way to refer the cell A10 on sheet3 from sheet1? A. Sheet3!A10 B. Sheet1!A10 C. Sheet3.A10 D. A10

7. Excel displays the current cell address in the ________ A. Formula bar B. Status Bar C. Name Box D. Title Bar

Formula bar
Status Bar
Name Box
Title Bar

Detailed SolutionExcel displays the current cell address in the ________ A. Formula bar B. Status Bar C. Name Box D. Title Bar

8. What is the short cut key to highlight the entire column? A. Ctrl + C B. Ctrl + Enter C. Ctrl + Page Up D. Ctrl + Space Bar

Ctrl + C
Ctrl + Enter
Ctrl + Page Up
Ctrl + Space Bar

Detailed SolutionWhat is the short cut key to highlight the entire column? A. Ctrl + C B. Ctrl + Enter C. Ctrl + Page Up D. Ctrl + Space Bar

9. In the formula, which symbol specifies the fixed columns or rows? A. $ B. * C. % D. &

$
*
%
&

Detailed SolutionIn the formula, which symbol specifies the fixed columns or rows? A. $ B. * C. % D. &

10. What does COUNTA () function do? A. Counts cells having alphabets B. Counts empty cells C. Counts cells having number D. Counts non-empty cells

Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells

Detailed SolutionWhat does COUNTA () function do? A. Counts cells having alphabets B. Counts empty cells C. Counts cells having number D. Counts non-empty cells

Page 1Page 2Page 3Page 4Page 5
Test 1Test 2Test 3