YouScience Review

In a spreadsheet, what is it called when more than one cell is selected?

• Set

• Group

• Range

• Table

Which of the following slide layouts is used to introduce a topic and set the tone for the presentation?

• Blank

• Title

• Bibliography

• Two content

What feature combines selected cells into one larger cell?

• Merge

• Realign

• Combine

• Split

Which symbol is used to indicate an absolute cell reference?

• $B$8

• *B*8

• !B!8

• #B#8

Which feature changes one long string of text to multiple-lines in one cell?

• Wrap Text

• Conditional Formatting

• Indentation

• Vertical Alignment

Match each function with its correct description

• Finds a specific value in a table based on a cell's value

• IF

• The number of cells that contain numbers

• LOOKUP

• The smallest value in a range of cells

• MIN

• The largest value in a range of cells

• COUNT

• Returns one of two values based on a logical test

• MAX

What word processing feature has rows, borders, and columns?

• Bulleted List

• Text Box

• Table

• Tab

Which page feature enablers a spreadsheet to be printed on a specific number of pages?

• Orientation

• Alignment

• Scaling

• Margins

What type of sort was applied to the table?

• Ascending

• Descending

• Sliding

• Upward

Which chart type would be used to show one piece of data compared to the whole?

• Bar Chart

• Column Chart

• Pie Chart

• Line Chart