D100 - Introduction to Spreadsheets

Question 1: Which of the following is a method for freezing rows and columns in Excel?

Use Conditional Formatting

Select "Freeze Panes" from the VIEW tab

Use the Insert tab to lock the cells

Highlight rows and click "Sort"

Question 2: What does Excel display when the width of a column is too narrow to display the entire content of a cell?

#DIV/0!

####

#VALUE!

Blank Cell

Question 3: Which of the following features can be used to display the formula used in a cell?

Show Formula

Trace Precedents

Evaluate Formula

Conditional Formatting

Question 4: How can you modify the width of a column to automatically fit the longest entry?

Drag the column manually

Double-click the border between two column headings

Use the "AutoFill" option

Apply Wrap Text

Question 5: Which of the following Excel functions returns the highest value in a range of cells?

SUM

MIN

MAX

AVERAGE

Question 6: In Excel, what is the use of a PivotTable?

To store raw data

To summarize and analyze data

To create 3D models

To write complex formulas

Question 7: What is the shortcut to quickly duplicate the contents of a cell into another cell directly below it?

Ctrl + V

Ctrl + C

Ctrl + D

Ctrl + P

Question 8: What does the VLOOKUP function do in Excel?

It vertically looks for a value in a table

It sums up all values in a column

It compares two different ranges

It extracts specific text from a string

Question 9: What is the function of the "Merge & Center" button?

Merge worksheets

Center the data across selected cells

Combine selected cells into one and center-align the content

Split the content of cells

Question 10: Which of the following is the correct formula to calculate the total of a range of cells?

=SUM(A1

=MAX(A1)

=ADD(A1)

Question 11:

Right-click the cell and select "Insert Comment"

Use the "Data" tab

Use the "Formulas" tab

Question 12:

SUM

AVERAGE

MEDIAN

Question 13:

Conditional Formatting

Cell Protection

Data Validation

Question 14:

Principal payment

Interest payment

Loan repayment

Question 15:

Ctrl + F

Ctrl + R

Ctrl + H

Question 16:

AutoFit

AutoFill

SUM

Question 17:

Currency

Text

General

Question 18:

=SUM(A1)

=MIN(A1)

=MAX(A1)

Question 19:

Conditional Formatting

Data Validation

Trace Precedents

Question 20:

Shift + F11

Ctrl + N

Ctrl + T

D100 Introduction to Spreadsheets - Set 2 - Part 1

Question 1: Which of the following is a method for freezing rows and columns in Excel?

Question 2: What does Excel display when the width of a column is too narrow to display the entire content of a cell?

Question 3: Which of the following features can be used to display the formula used in a cell?

Question 4: How can you modify the width of a column to automatically fit the longest entry?

Question 5: Which of the following Excel functions returns the highest value in a range of cells?

Question 6: In Excel, what is the use of a PivotTable?

Question 7: What is the shortcut to quickly duplicate the contents of a cell into another cell directly below it?

Question 8: What does the VLOOKUP function do in Excel?

Question 9: What is the function of the "Merge & Center" button?

Question 10: Which of the following is the correct formula to calculate the total of a range of cells?

Question 11:

Question 12:

Question 13:

Question 14:

Question 15:

Question 16:

Question 17:

Question 18:

Question 19:

Question 20:

Need Guaranteed Results?