wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

CS 201 Quiz 2

Total questions: 70

Worksheet time: 35mins

Name
Class
Date
1.

What is the main purpose of What-If Analysis in Excel?

a)

To see how changes in input affect output

b)

To format worksheets

c)

To sort data

d)

To create charts

2.

Which What-If tool is used when you already know the desired output and want to find the needed input?

a)

Data Table

b)

Solver

c)

Scenario Manager

d)

Goal Seek

3.

What does Scenario Manager allow you to create?

a)

Multiple scenarios using different input sets

b)

Only one scenario

c)

Data ranges

d)

Cell references

4.

Which tool can handle multiple constraints and find optimal solutions?

a)

Goal Seek

b)

Data Table

c)

Scenario Manager

d)

Solver

5.

What-If Analysis helps users primarily with:

a)

Decision-making and forecasting

b)

Cell formatting

c)

File conversion

d)

Printing worksheets

6.

In a one-variable data table, how many input cells can change?

a)

Two

b)

One

c)

Three

d)

Unlimited

7.

In a two-variable data table, the values are placed in:

a)

Only one column

b)

Row and column

c)

Dialog boxes

d)

Worksheets only

8.

Which of the following is NOT a What-If Analysis tool?

a)

Goal Seek

b)

Scenario Manager

9.

Goal Seek requires the Set Cell to contain a:

a)

Formula

b)

Text entry

c)

Chart

d)

Comment

10.

Solver is used to:

a)

Access filters

b)

Perform formatting

c)

Compare scenarios

d)

Maximize or minimize a formula value

11.

In Scenario Manager, “changing cells” refer to:

a)

The cells where input values vary

b)

Only output cells

c)

Locked cells

d)

Cells with text

12.

In a two-variable data table, the row input and column input must be:

a)

Formatting cells

b)

Input cells referenced by the formula

c)

Empty cells

d)

Cells with labels

13.

Data Tables are best used when analyzing:

a)

Multiple sheet layouts

b)

One or two variables across many values

c)

Pivot tables

d)

Cell protection

14.

In Goal Seek, the “By Changing Cell” refers to:

a)

The variable we want to adjust

b)

A result cell

c)

A cell with text

d)

A locked cell

15.

Solver can enforce which of the following?

a)

Data table limits

b)

Print scale

c)

Conditional formatting

d)

Constraints on variables

16.

A scenario summary report in Scenario Manager shows:

a)

The result of all scenarios side-by-side

b)

A chart only

c)

Only the original dataset

d)

Solver constraints

17.

Data tables automatically recalculate when the:

a)

Sheet is closed

b)

Input values or formulas change

c)

Workbook is renamed

d)

Filter is applied

18.

Scenario Manager is most useful when:

a)

Changing only one variable

b)

Testing multiple possibilities with several inputs

c)

Sorting values

d)

Printing data

19.

Goal Seek works by adjusting:

a)

A. A single input value

b)

B. Multiple input ranges

c)

C. Pivot table fields

d)

D. Chart styles

20.

Solver is most appropriate when:

a)

Finding required input for one result

b)

Running one-variable tables

c)

Comparing two scenarios only

d)

Optimizing results with constraints

21.

Which What-If Analysis tool allows you to store different sets of input values without overwriting existing data?

a)

Goal Seek

b)

Solver

c)

Scenario Manager

d)

Flash Fill

22.

In a Data Table, the formula must be placed where?

a)

In the top-left corner of the table

b)

In any empty cell

c)

In the bottom-right corner

d)

Inside the Scenario Manager dialog

23.

Which tool is best when you need to test many combinations of two variables at once?

(a)  

24.

Solver’s objective cell must contain:

a)

A. A text label

b)

B. A formula to optimize

c)

C. Conditional formatting

d)

D. A constant number

25.

Scenario Manager cannot change which of the following?

a)

Numbers in input cells

b)

Text in input cells

c)

Formulas

d)

Values in a scenario report

26.

Which statistical function is used to determine the rank of a number within a data set?

a)

LARGE

b)

AVEDEV

c)

AVERAGEA

d)

RANK.EQ

27.

In the Math and Trigonometry category, which function is specifically used to convert a value expressed in radians into degrees?

a)

DEGREES

b)

RADIANS

c)

COS

d)

ASIN

28.

Which statistical function should be used when counting the number of cells that satisfy a single, specified condition?

a)

COUNTIFS

b)

COUNTIF

c)

COUNTBLANK

d)

COUNT

29.

When calculating a logarithm in a base other than 10 or e, which of the following functions is appropriate?

a)

LN

b)

LOG

c)

LOG10

d)

EXP

30.

Which Math function is used to multiply all of its input values together?

(a)  

31.

From the list of trigonometric functions, which one returns the cosine of a given number?

a)

COSH

b)

CSC

c)

SEC

d)

COS

32.

Which lookup function searches the top row of a table and returns a value from a specified column beneath it?

a)

VLOOKUP

b)

LOOKUP

c)

HLOOKUP

d)

MATCH

33.

Which logical function returns TRUE only when every condition provided evaluates to TRUE?

a)

A. AND

b)

B. OR

c)

C. XOR

d)

D. NOT

34.

Which Math function calculates how many combinations are possible when selecting items, regardless of the order of selection?

a)

PERMUT

b)

PERMUTATIONA

c)

COMBIN

d)

COMBINA

35.

Which function returns the absolute value of a number, removing any negative sign?

a)

ABS

b)

SIGN

c)

TRUNC

d)

EVEN

36.

Which statistical function counts the number of empty cells within a given range?

a)

COUNT

b)

COUNTBLANK

c)

COUNTA

d)

COUNTIF

37.

When determining the middle value in a list of numbers, which function should be used?

a)

AVERAGE

b)

MEDIAN

c)

MODE.SNGL

d)

MINA

38.

Which function provides subtotal calculations within a list or database?

a)

SUMIFS

b)

SUMXMY2

c)

SUM

d)

SUBTOTAL

39.

Which lookup and reference function returns a cell reference in text form, such as “B5”?

a)

ADDRESS

b)

INDIRECT

c)

COLUMN

d)

INDEX

40.

Which database function is designed to extract a single record that meets specified criteria?

a)

DCOUNT

b)

DSUM

c)

DVAR

d)

DGET

41.

Which Math function returns only the positive square root of a number?

a)

SQRT

b)

SQRTPI

c)

TAN

d)

SIGN

42.

Which logical function reverses the truth value of its argument?

a)

AND

b)

NOT

c)

OR

d)

XOR

43.

Which function rounds a number upward, moving it away from zero?

a)

ROUNDUP

b)

ROUNDDOWN

c)

EVEN

d)

FLOOR

44.

Which statistical function is used to retrieve the k-th largest value in a dataset?

a)

MINA

b)

MEDIAN

c)

LARGE

d)

RSQ

45.

Which function returns a value from a specific position within a referenced range or array?

a)

INDEX

b)

ROW

c)

XMATCH

d)

WRAPROWS

46.

Which function returns the remainder after dividing two numbers?

a)

QUOTIENT

b)

MOD

c)

INT

d)

ROUND

47.

In Excel, which function is used to return the number of rows in a range?

a)

COLUMNS

b)

ROWS

c)

INDEX

d)

OFFSET

48.

Which function returns the current date and time?

a)

TODAY()

b)

NOW()

c)

DATE()

d)

TIME()

49.

Which function is used to extract a substring from the middle of a text string?

a)

LEFT

b)

RIGHT

c)

MID

d)

FIND

50.

How do you reference the same cell across multiple worksheets?

a)

=Sheet1:Sheet3!A1

b)

=A1

c)

=Sheet1+A1

d)

=Sheet1.A1

51.

In Excel, grouping worksheets allows you to:

a)

Enter data in all grouped sheets simultaneously

b)

Lock sheets from editing

52.

A 3-D formula is used to:

a)

Format multiple sheets

b)

Perform calculations across multiple sheets

c)

Import external data

d)

Audit formulas

53.

Trace Precedents in Excel helps to:

a)

Highlight cells that depend on a selected cell

b)

Import data from the web

c)

Combine text from different cells

d)

Merge worksheets

54.

Data Validation is used to:

a)

Restrict the type of data that can be entered in a cell

b)

Sum data across multiple sheets

c)

Format text

d)

Refresh external data

55.

To import data from an external web page, you would use:

a)

Get & Transform (Power Query)

b)

CONCATENATE

c)

MID

d)

INDIRECT

56.

Which function extracts a specific number of characters from the start of a text string?

a)

RIGHT

b)

LEFT

c)

MID

d)

LEN

57.

When a linked workbook is moved or deleted, Excel will display:

a)

Blank cell

b)

#REF! error

c)

Automatically update link

d)

Warning but retain old data

58.

To combine text from multiple cells into one cell, you use:

a)

MID

b)

REPLACE

c)

CONCATENATE

d)

VALUE

59.

How can you refresh data imported from an external source?

a)

Refresh All

b)

Edit Links

c)

Paste Values

d)

Conditional Formatting

60.

In XML mapping, the XML Source Pane allows you to:

a)

Map XML elements to worksheet cells

b)

Create a pivot table

c)

Validate formulas

d)

Lock worksheets

61.

Data Validation can prevent:

a)

Invalid data entry

b)

Text formatting

c)

Worksheet grouping

d)

Pivot table errors

62.

To enter the same formula in multiple worksheets at once, you should:

a)

Copy and paste individually

b)

Group the sheets and enter formula

c)

Use HLOOKUP

d)

Use CONCATENATE

63.

Which feature highlights errors or inconsistencies in formulas?

a)

SUM

b)

Error Checking

c)

COUNTIF

d)

Pivot Table

64.

Trace Dependents in Excel shows:

a)

Which cells rely on the value of the selected cell

b)

How to import external data

c)

How to concatenate text

d)

How to format multiple sheets

65.

Importing XML data allows you to:

a)

Analyze structured data

b)

Perform SUM calculations

c)

Merge multiple worksheets

d)

Apply conditional formatting

66.

The PROPER function in text manipulation:

a)

Capitalizes the first letter of each word

b)

Converts all text to lowercase

c)

Extracts leftmost characters

67.

The UPPER function is used to:

a)

Convert text to lowercase

b)

Convert text to uppercase

c)

Split text

d)

Find errors in text

68.

Linked workbooks automatically update when:

a)

Source data changes

b)

You press Ctrl+C

c)

You copy and paste values

d)

Workbook is closed

69.

Which function extracts characters from the middle of a text string?

a)

MID

b)

LEFT

c)

RIGHT

d)

LEN

70.

When importing XML, validating against the schema ensures:

a)

The data follows the correct structure

b)

Text formatting is applied

c)

Linked workbooks update

d)

Pivot tables refresh

Similar Resources on Wayground

Gestão de Aquisições

68 questions

Gestão de Aquisições

quiz

Worksheet

•

University

1 History of Python

69 questions

1 History of Python

quiz

Worksheet

•

University

NETWORKING 1 FINAL EXAMINATION

70 questions

NETWORKING 1 FINAL EXAMINATION

quiz

Worksheet

•

University

ICT 70

70 questions

ICT 70

quiz

Worksheet

•

University

Mock Test - Ethical Hacking

70 questions

Mock Test - Ethical Hacking

quiz

Worksheet

•

University

Bảo mật hệ thống thông tin - Trắc nghiệm

69 questions

Bảo mật hệ thống thông tin - Trắc nghiệm

quiz

Worksheet

•

University

Ôn kiểm thử P1

70 questions

Ôn kiểm thử P1

quiz

Worksheet

•

University

Remidi UAS_Basis Data Lanjut_Ekstensi_2025

70 questions

Remidi UAS_Basis Data Lanjut_Ekstensi_2025

quiz

Worksheet

•

University