wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

LONG QUIZ 1

Total questions: 70

Worksheet time: 39mins

Name
Class
Date
1.

You need to fit a large worksheet onto one page for printing. What feature should you use?

a)

Margins

b)

Orientation

c)

Scale to Fit

d)

Page Setup

2.

Your document's data is too close to the edge of the page. Which option should you adjust?

a)

Print Area

b)

Page Layout > Margins

c)

Page Breaks

d)

Orientation

3.

You need to print a wide dataset. Which option should you choose?

a)

Portrait

b)

Landscape

c)

Margins > Narrow

d)

Page Break Preview

4.

You need to control where Excel starts a new printed page. What feature should you use?

a)

Print Preview

b)

Page Break Preview

c)

Set Print Area

d)

Custom Margins

5.

You want to add a watermark or background image to your sheet. What option do you use?

a)

Insert Tab > Image

b)

Page Layout > Background

c)

Format Cells > Fill

d)

View Tab > Custom Views

6.

You want to hide gridlines when printing the worksheet. What should you do?

a)

Remove borders from the cells.

b)

Uncheck Gridlines in Page Layout.

c)

Use Conditional Formatting.

d)

Change the worksheet background color.

7.

You want row and column headers to appear on every printed page. Which feature will you use?

a)

Page Layout > Print Area

b)

Page Layout > Print Titles

c)

File > Print

d)

View > Page Break Preview

8.

You need to change the fonts and colors across your workbook for consistency. Which option should you use?

a)

Page Layout > Themes

b)

View > Page Layout

c)

Format Cells > Font

d)

Home > Conditional Formatting

9.

You want a logo behind the cells but don't want it to interfere with data. What do you use?

a)

Page Layout > Background

b)

Insert Tab > Shapes

c)

Conditional Formatting

d)

View > Page Layout

10.

Your content gets cut off when printed. Which settings should you adjust?

a)

Page Breaks

b)

Borders

c)

Margins and Scaling

d)

Orientation

11.

You want to see which cells contribute to the value of a formula. Which feature will you use?

a)

Evaluate Formula

b)

Show Formulas

c)

Trace Precedents

d)

Watch Window

12.

Your formula returns an incorrect result. Which tool helps debug it step by step?

a)

Trace Dependents

b)

Evaluate Formula

c)

Error Checking

d)

Formula Bar

13.

You want to simplify a formula by using a defined name instead of cell references. Which feature should you use?

a)

Trace Precedents

b)

Define Name

c)

AutoSum

d)

Goal Seek

14.

You see a green triangle in a cell containing a formula. What does this indicate?

a)

The formula is invalid.

b)

The cell contains a potential error flagged by Error Checking.

c)

The formula contains external links.

d)

Circular reference exists.

15.

You need to see all formulas in a sheet instead of their results. What should you do?

a)

Click Show Formulas under the Formulas tab.

b)

Use the Evaluate Formula tool.

c)

Open the Watch Window.

d)

Enter each formula manually in the Formula Bar.

16.

What does Excel do when a formula refers back to its own cell?

a)

Returns an error.

b)

Automatically resolves it.

c)

Flags it as a Circular Reference.

d)

Deletes the formula.

17.

You want to monitor the results of key formulas while working on a different part of the workbook. What feature should you use?

a)

Trace Dependents

b)

Evaluate Formula

c)

Watch Window

d)

Show Formulas

18.

Which shortcut quickly calculates the sum of a column or row?

a)

CTRL + SHIFT + S

b)

Formulas > AutoSum

c)

ALT + Enter

d)

Insert > Function

19.

You want a formula to return a specific result by adjusting a single input. Which tool should you use?

a)

Data Validation

b)

Scenario Manager

c)

Goal Seek

d)

Solver

20.

You want to see which cells depend on the value of a specific cell. Which feature will you use?

a)

Trace Dependents

b)

Trace Precedents

c)

Evaluate Formula

d)

Error Checking

21.

You want to restrict input in a cell to whole numbers between 1 and 100. What should you use?

a)

Conditional Formatting

b)

Data Validation

c)

Filter

d)

Goal Seek

22.

You want to split data in one column into two based on a delimiter. Which tool should you use?

a)

Flash Fill

b)

Text to Columns

c)

Data Validation

d)

Pivot Table

23.

You have a column of names in 'First Last' format but need to separate them into two columns. What tool will help?

a)

Text to Columns

b)

Flash Fill

c)

CONCAT

d)

Data Validation

24.

You want to clean your data by eliminating duplicate entries. What should you do?

a)

Use Conditional Formatting

b)

Use Remove Duplicates under the Data tab

c)

Filter the dataset

d)

Use Advanced Filtering

25.

You need to summarize data from multiple sheets into one. Which tool will you use?

a)

Flash Fill

b)

Pivot Table

c)

Consolidate

d)

Text to Columns

26.

You want to arrange your data alphabetically by the first column. What feature should you use?

a)

Filter

b)

Sort

c)

Remove Duplicates

d)

Data Validation

27.

You need to extract rows that meet specific criteria to another location. Which tool is best?

a)

Sort

b)

Filter

c)

Advanced Filter

d)

Flash Fill

28.

What feature helps you summarize and analyze large datasets dynamically?

a)

Advanced Filter

b)

Pivot Table

c)

Data Validation

d)

Goal Seek

29.

You want to pull data from an external database into Excel. What feature should you use?

a)

Pivot Table

b)

Get Data > Connections

c)

Flash Fill

d)

Consolidate

30.

You need to test multiple scenarios for how a change in input will affect output. Which tool is most useful?

a)

Goal Seek

b)

What-If Analysis > Scenario Manager

c)

Pivot Table

d)

Text to Columns

31.

All formulas in Excel begin with what?

a)

Mathematical Function

b)

Parenthesis

c)

Equal Sign

d)

Cell Choice

32.

To format numbers as money, you would choose what?

a)

Numbers

b)

General

c)

Currency

d)

Increase Decimals

33.

This key screen area allows you to name your ranges, shapes, or pictures.

a)

Formula Bar

b)

Ribbon

c)

Name Box

34.

This is where any calculations or formulas you write will appear.

a)

Status Bar

b)

Formula Bar

c)

Quick Access Toolbar

35.

If you want to set the print area of your worksheet, what tab should you go?

a)

Insert

b)

View

c)

Page Layout

36.

You will find the Data Validation feature in what tab?

a)

Review

b)

Formulas

c)

Data

37.

Which function calculates the average number in a range?

a)

Average

b)

sum and divide by the number

c)

Autosum

d)

Sum

38.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
39.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
40.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
41.

Which formula will calculate the average based on a condition? (return the average of sales if over $20)

a)

average

b)

countif

c)

averageif

d)

sumif

42.

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?

a)

It's the easiest way to make a backup before making changes.

b)

It lets you reuse formats and formulas in a new sheet.

c)

It helps Excel learn where your data ranges are located.

d)

You should keep one worksheet hidden in case of an error.

43.
For which of the following tasks would you use the fill handle?
a)
to apply shading 
b)
to apply a border
c)
to copy a formula from cell A2 to cell A3
44.
Which view do you need to work in to add a header?
a)
Normal View
b)
Page Layout view
c)
Header/Footer view
d)
Page Setup View
45.

What is a pre-written formula called?

a)

Feature

b)

Function

c)

Task

d)

Calculation

46.
A ____ is a prewritten formula that is built into Excel.
a)
function
b)
feature
c)
task
d)
calculation
47.
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
a)
placement
b)
operations
c)
positioning
d)
selections
48.
Which of the following happens when you enter the formula =G15 into a cell?
a)
Excel recalculates all formulas in the worksheet
b)
Excel assigns the sum of the values in the previous 15 cells to the active cell
c)
Excel assigns the value in cell G15 to the active cell
d)
Nothing; =G15 is an invalid formula
49.
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
a)
Formula Finder
b)
Range Finder
c)
Calculation Finder
d)
Function Finder
50.
Best fit means that the width of the column will be increased or decreased by a percentage you specify.
a)
true
b)
false
51.

What is the purpose of the 'Text to Columns' feature in Excel?

a)

To change the font style of the text

b)

To calculate the sum of the text in the column

c)

To delete the entire column of text

d)

To split a single column of text into multiple columns based on a delimiter

52.

Explain the concept of 'Flash Fill' in Excel.

a)

Automatically deleting values based on recognized patterns

b)

Manually inputting values based on recognized patterns

c)

Automatically formatting values based on recognized patterns

d)

Automatically fills in values based on recognized patterns

53.

How can you remove duplicate values from a column in Excel?

a)

Use the 'Add Duplicates' feature in the Data tab

b)

Use the 'Remove Duplicates' feature in the Data tab

c)

Manually delete each duplicate value

d)

Use the 'Duplicate Remover' tool in the Review tab

54.

What is data validation in Excel and how is it useful?

a)

It is a feature that allows you to control the type of data that can be entered into a cell, and it is useful for ensuring data accuracy and consistency.

b)

It is a feature that allows you to play games within Excel, and it is useful for taking a break from work.

c)

It is a feature that allows you to send emails directly from Excel, and it is useful for communication with colleagues.

d)

It is a feature that allows you to change the color of cells in Excel, and it is useful for making the spreadsheet look more visually appealing.

55.

What are the different options available in the 'Text to Columns' feature?

a)

Copy, Paste, Cut

b)

Bold, Italic, Underline

c)

Delimiter, Fixed width, and Date

d)

Merge, Split, Align

56.

How does 'Flash Fill' help in data manipulation in Excel?

a)

It allows users to send flash messages in Excel

b)

It automatically fills in values based on recognized patterns.

c)

It changes the color of the cells in Excel

d)

It creates a flash animation in the Excel sheet

57.

What are the steps to remove duplicate rows in Excel?

a)

Format the cells

b)

Open a new workbook

c)

Sort the data alphabetically

d)

Go to the Data tab and click on Remove Duplicates

58.

What are the advantages of using the 'Consolidate' feature in Excel?

a)

It deletes all the data in the spreadsheet

b)

It allows you to combine data from multiple ranges into one summary range.

c)

It can only be used for a single range, not multiple ranges

d)

It only works for text data, not numbers

59.

Which tab can give you the option to sort your data from highest to oldest / oldest to newest (And vice-versa)?

a)

Home

b)

Data

c)

Formulas

d)

Insert

60.

What do you call the entries that have no value associated with them?

a)

Formula

b)

Text

c)

Value

d)

Art

61.

Which tab will enable you to add or insert graphs and charts?

a)

Home

b)

Data

c)

Formula

d)

Insert

62.

How do you insert a hyperlink in Excel?

a)

Insert > Table

b)

Insert > Illustrations

c)

Insert > Links > Hyperlink

d)

Insert > Text > Hyperlink

63.

Where can you insert a pivot table from the Insert tab?

a)

Illustrations group

b)

Charts group

c)

Tables group

d)

Links group

64.

Which of the following is NOT part of the Home tab?

a)

Bold

b)

Insert Chart

c)

Conditional Formatting

d)

Wrap Text

65.

What is the purpose of the Insert Tab in Excel?

a)

To check spelling

b)

To insert tables and charts

c)

To change the font

d)

To save the workbook

66.

If cell A1 contained the number 1 and you used AutoFill to fill the cells automatically down to A20, what number would be in cell A20?

a)

1

b)

2

c)

10

d)

20

67.

Which tab would I go to to add a chart to my worksheet?

a)

Home

b)

Formulas

c)

Data

d)

Insert

68.

Which command in the Insert tab is used to add a table to a worksheet?

a)

PivotTable

b)

Table

c)

Chart

d)

Shapes

69.

The "Header & Footer" option is found under which tab?

a)

Home

b)

Insert

c)

File

d)

View

70.

Which of the following can you insert from the Text group in the Insert tab?

a)

Header & Footer

b)

Data Validation

c)

Filter

d)

Format as Table

Similar Resources on Wayground

Computer architectuur

72 questions

Computer architectuur

quiz

Worksheet

•

5th - 12th Grade

H446 Section 1: Components of a computer

71 questions

H446 Section 1: Components of a computer

quiz

Worksheet

•

11th Grade - University

Word Within The Word Lists 1-3

75 questions

Word Within The Word Lists 1-3

quiz

Worksheet

•

3rd Grade - University

Cambridge - IGCSE - Computer Science - Input Devices

66 questions

Cambridge - IGCSE - Computer Science - Input Devices

quiz

Worksheet

•

11th Grade - Professi...

Mikrotik Lesson

72 questions

Mikrotik Lesson

quiz

Worksheet

•

12th Grade

5.0 - Standard Camp Final

75 questions

5.0 - Standard Camp Final

quiz

Worksheet

•

6th - 12th Grade

Examen de Diagnostico de Tecnologia

65 questions

Examen de Diagnostico de Tecnologia

quiz

Worksheet

•

9th - 12th Grade

Programare și Dezvoltare Web

70 questions

Programare și Dezvoltare Web

quiz

Worksheet

•

10th - 12th Grade