Quiz about WORD PROCESSING-SPREADSHEET - FINALS

Question 1

How many blank worksheets are shown when a new workbook is created?

Accepted Answer

3

Answer

1

Answer

2

Answer

4

Question 2

Which step completes an entry and moves the pointer to the cell to the right?

Accepted Answer

Pressing [Tab]

Answer

Pressing [Enter]

Answer

Pressing [Shift]+[Tab]

Answer

Pressing [Shift]+[Enter]

Question 3

Which mathematical operator is represented by an asterisk (*)?

Accepted Answer

Multiplication

Answer

Exponentiation

Answer

Addition

Answer

Subtraction

Question 4

Which function automatically totals a column or row of values?

Accepted Answer

SUM

Answer

AVG

Answer

ADD

Answer

TOTAL

Question 5

Which cell alignment is assigned to most values by default?

Accepted Answer

Left

Answer

Right

Answer

Centre

Answer

Decimal

Question 6

Which function results can be displayed in AutoCalculate?

Accepted Answer

SUM and AVERAGE

Answer

MAX and LOOK

Answer

LABEL and AVERAGE

Answer

MIN and BLANK

Question 7

Which command allows you to reverse an Undo command?

Accepted Answer

Redo

Answer

Repeat

Answer

Reset

Answer

Reverse

Question 8

Which key when pressed displays the access keys?

Accepted Answer

[Alt]

Answer

[Ctrl]

Answer

[Shift]

Answer

[Esc]

Question 9

When navigating in a workbook, which command is used to move to the beginning of the current row?

Accepted Answer

[Home]

Answer

[Ctrl]+[Home]

Answer

[Page Up]

Answer

[Ctrl]+[Backspace]

Question 10

Which command reverses the last action performed in the worksheet?

Accepted Answer

Undo

Answer

Paste

Answer

Redo

Answer

Cut

Question 11

Where is the address of the active cell displayed?

Accepted Answer

Name Box

Answer

Row heading

Answer

Status bar

Answer

Formula bar

Question 12

As you type a number in a cell, what mode appears in the status bar?

Accepted Answer

Enter mode

Answer

Ready mode

Answer

Edit mode

Answer

Record mode

Question 13

Which view shows margins and the rulers?

Accepted Answer

Page Layout

Answer

Normal

Answer

Page Setup

Answer

Review

Question 14

Which key combination collapses the ribbon?

Accepted Answer

[Ctrl]+[F1]

Answer

[Ctrl]+[F3]

Answer

[Ctrl]+[F5]

Answer

[Ctrl]+[F7]

Question 15

The AutoAdd function adds up numbers in a column or row you specify

Accepted Answer

FALSE

Answer

TRUE

Question 16

"CCC" is an example of a ____ in Excel.

Accepted Answer

column heading

Answer

cell reference

Answer

name box

Answer

row heading

Question 17

_______ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets.

Accepted Answer

conditional formatting

Answer

cell references

Answer

Excel tables

Answer

pivot tables

Question 18

The best formula to calculate Profits for January is:

Accepted Answer

=B2-B3

Answer

=SUM(B2:B3)

Answer

=B4-(B2+B3)

Answer

=A4-(A2+A3)

Answer

=SUBTRACT(B2:B3)

Question 19

The best formula to calculate the Average for Profits is:

Accepted Answer

=AVERAGE(B4:D4)

Answer

=(B4+C4+D4)/3

Answer

=MEAN(B4:E4)

Answer

=AVERAGE(B4:E4)

Question 20

As a general rule, Excel will _____-align numbers.

Accepted Answer

right

Answer

left

Answer

top

Answer

bottom

Question 21

Cell D4 contains the formula =C1+C2. What formula will see when you paste this into cell E5?

Accepted Answer

=D2+D3

Answer

=C1+C2

Answer

=$C1+$C2

Answer

=E6+E7

Question 22

When you copy a formula that contains an absolute reference to a new location, the reference ____.

Accepted Answer

does not change

Answer

is updated automatically

Answer

becomes bold

Answer

has a dotted outline in its cell

Question 23

Which of the following is a logical function?

Accepted Answer

IF

Answer

AVERAGE

Answer

SUMPRODUCT

Answer

VLOOKUP

Question 24

The image above shows a:

Accepted Answer

Column chart

Answer

Bar graph

Answer

Line Chart

Answer

Pie Chart

Question 25

____ order arranges content in reverse alphabetical order, from Z to A

Accepted Answer

Descending

Answer

Reverse

Answer

Major

Answer

Ascending

Question 26

A worksheet ____ is a collection of two or more selected worksheets.

Accepted Answer

group

Answer

index

Answer

roster

Answer

cluster

Question 27

The ______ function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE.

Accepted Answer

OR

Answer

AND

Answer

SOME

Answer

LOOKUP

Question 28

To determine the number of sales people by region who have 50 or more orders, we use the:

Accepted Answer

COUNTIFS

Answer

COUNT

Answer

COUNTA

Answer

COUNTIF

Question 29

Removes all spaces from text except for single spaces between words.

Accepted Answer

CLEAN

Answer

CODE

Answer

TRIM

Answer

SUBSTITUTE

Question 30

An Excel file is called a workbook?

Accepted Answer

TRUE

Answer

FALSE

Question 31

You can format text in a cell in Excel.

Accepted Answer

True

Answer

False

Question 32

Excel automatically adjusts row height to accommodate the size of data in a row.

Accepted Answer

True

Answer

False

Question 33

To add color to a row or column you click the ___.

Accepted Answer

Fill color button (paint pail)

Answer

Click the font color button.

Answer

Set a colored border

Question 34

You can create mixed references by placing a dollar sign in front of only the column letter or only the row number.

Accepted Answer

TRUE

Answer

FALSE

Question 35

You can insert a row by right clicking a column heading.

Accepted Answer

FALSE

Answer

TRUE

Question 36

You can cut and paste data from one cell into another. Instead of using the mouse to do the cut and paste, you can use the keyboard. To cut press _________; to paste, press

Accepted Answer

CTRL+X and CTRL+V

Answer

CTRL+C and CTRL+V

Answer

CTRL+A and CTRL+V

Answer

CTRL+V and CTRL+X

Question 37

If you look at a worksheet and cannot see certain columns, it is probably because the worksheet has ___ columns.

Accepted Answer

Hidden

Answer

Unhidden

Answer

Deleted

Answer

Archive

Question 38

Which of the following features allows you to limit down the data in your worksheet?

Accepted Answer

filters

Answer

relative cell references

Answer

sorting

Answer

merge cells

Question 39

Left-aligned by default

Accepted Answer

Text data

Answer

Active cell

Answer

Formula

Answer

Numeric data

Question 40

After choosing copy or cut, the range affected is surrounded by a dotted line;

spreadsheets typically leave cut data in place until it is pasted elsewhere

Accepted Answer

True

Answer

Sometimes False

Answer

Sometimes True

Answer

False

WORD PROCESSING-SPREADSHEET - FINALS

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Mathematics