Author name: Umar Draz

educationist

A file in MS Excel is known as a:

A. Document

B. Slide

C. Workbook

D. Worksheet

Correct answer is: C. Workbook

What is the default file extension for an Excel 2016 workbook?

A. .docx

B. .pptx

C. .xlsx

D. .xls

Correct answer is: C. .xlsx

In Excel, a combination of a column letter and a row number (e.g., A1 or B4) is called a:

A. Cell Address / Cell Reference

B. Cell Pointer

C. Range

D. Formula

Correct answer is: A. Cell Address / Cell Reference

Which function is used to add a range of cells?

A. AVERAGE

B. SUM

C. ADD

D. TOTAL

Correct answer is: B. SUM

Which function would you use to find the largest number in a range?

A. MIN

B. MAX

C. LARGE

D. COUNT

Correct answer is: B. MAX

The intersection of a column and a row is called a:

A. Cell

B. Sheet

C. Box

D. Tab

Correct answer is: A. Cell

Which function calculates the average of numbers?

A. SUM

B. COUNT

C. AVERAGE

D. TOTAL

Correct answer is: C. AVERAGE

The small green square used to copy formulas to adjacent cells is the:

A. Copy handle

B. Fill Handle

C. Drag handle

D. Insert handle

Correct answer is: B. Fill Handle

Columns in Excel are labeled with:

A. Numbers

B. Letters

C. Symbols

D. Both letters and numbers

Correct answer is: B. Letters

Rows in Excel are labeled with:

A. Letters

B. Symbols

C. Numbers

D. Roman numerals

Correct answer is: C. Numbers