info systems Excel exam mod 1-3

0.0(0)
Studied by 12 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/71

encourage image

There's no tags or description

Looks like no tags are added yet.

72 Terms

1
New cards

What is the File tab used for?

Opening, saving, printing, and managing workbooks.

2
New cards

What is the Home tab used for?

Formatting text, cells, numbers, and alignment.

3
New cards

What is the Insert tab used for?

Adding charts, tables, pictures, and other objects.

4
New cards

What is the Page Layout tab used for?

Changing themes, margins, page orientation, and page setup.

5
New cards

What is the Formulas tab used for?

Finding and inserting formulas and functions.

6
New cards

What is the Data tab used for?

Sorting, filtering, and managing data.

7
New cards

What is the Review tab used for?

Checking spelling, adding comments, and protecting worksheets.

8
New cards

What is the View tab used for?

Changing worksheet views, zoom, and Freeze Panes.

9
New cards

What is the Name Box?

The box that shows the address of the selected cell.

10
New cards

What is the Formula Bar?

The area that shows or lets you edit the contents of a cell.

11
New cards

What is a workbook?

The entire Excel file.

12
New cards

What is a worksheet?

One spreadsheet inside a workbook.

13
New cards

rows vs columns

rows- horizontal and numbered. columns- vertical lines and lettered

14
New cards

What is a cell?

The box where a row and column meet.

15
New cards

What is a cell reference?

The address of a cell, such as A1.

16
New cards

How do text and numbers align by default?

Text aligns left, and numbers align right.

17
New cards

How do you use AutoSum?

Select the answer cell, click Home, click AutoSum (Σ), check the range, and press Enter.

18
New cards

What formula adds cells A1 through A5?

=SUM(A1:A5)

19
New cards

What is an Excel function?

A built-in formula that performs a calculation.

20
New cards

What symbol does every formula start with?

An equal sign (=).

21
New cards

What is the Fill Handle?

The tiny square in the bottom-right corner of a selected cell.

22
New cards

How do you use the Fill Handle?

Click a cell, drag the tiny square down or across, and release.

23
New cards

How do you apply a Cell Style?

Select the cells, click Home, choose Cell Styles, and pick a style.

24
New cards

What formatting tools are available in Excel?

Bold, italic, underline, font size, font color, fill color, borders, and alignment.

25
New cards

How do you create a pie chart?

Highlight your data, click Insert, select Pie Chart, and choose a chart style.

26
New cards

What is a pie chart used for?

Showing parts of a whole.

27
New cards

How do you change a worksheet tab color?

Right-click the sheet tab, select Tab Color, and choose a color.

28
New cards

How do you change document properties? What are examples of document properties?

Click File, select Info, find Properties, and edit the information. → Title, author, subject, and keywords.

29
New cards

What is the AutoCalculate area?

The bottom status bar that displays statistics about selected cells.

30
New cards

What does #DIV/0! mean?

You are dividing by zero.

31
New cards

What does #VALUE! mean?

The formula has an incorrect type of value.

32
New cards

What does #REF! mean?

The formula contains an invalid cell reference.

33
New cards

What does #NAME? mean?

Excel does not recognize something in the formula.

34
New cards

What does ##### mean?

The column is too narrow to show the information.

35
New cards

What is Flash Fill?

A tool that automatically fills information by recognizing a pattern.

36
New cards

How do you use Flash Fill?

Type an example, click Data, and select Flash Fill.

37
New cards

What is the Flash Fill shortcut?

Ctrl + E.

38
New cards

How do you enter a formula using the keyboard?

Type =, enter the cell references and math symbols, and press Enter.

39
New cards

What is Range Finder and how do you use it

A tool that helps identify which cells are used in a formula. Select the formula cell and press F2 to highlight the cells used in the formula.

40
New cards

How do you apply a theme to a workbook?

Click Page Layout, select Themes, and choose a theme.

41
New cards

How do you apply a date format?

Select the cells, click Home, open Number Format, and choose Short Date or Long Date.

42
New cards

What is an example of a Short Date? vs 72. What is an example of a Long Date?

11/17/2026. → Tuesday, November 17, 2026.

43
New cards

What is Conditional Formatting? and How do you apply Conditional Formatting?

A tool that changes cell colors or styles based on rules; Select cells, click Home, choose Conditional Formatting, select a rule, and click OK. An example of cond. form. is to highlight grades below 70 in red.

44
New cards

How do you change column width and height

Drag the line between column letters;Drag the line between row numbers.

45
New cards

What does AutoFit do?

Automatically adjusts the size of a column or row to fit the information.

46
New cards

How do you check spelling in Excel?

Click Review and select Spelling. (f7 is the shortcut)

47
New cards

How do you change worksheet margins?

Go to Page Layout, click Margins, and select Normal, Wide, or Narrow.

48
New cards

How do you add a header/footer?

Go to Page Layout view, click Add Header/footer, and type your information.

49
New cards

How do you print only part of a worksheet?

Highlight the cells, click Page Layout, select Print Area, and choose Set Print Area.

50
New cards

How do you rotate text in a cell?

Select the cell, click Home, click Orientation, and choose a rotation.

51
New cards

How do you create a series of month names?

Type January and drag the Fill Handle down.

52
New cards

How do you insert cells?→ 92. How do you delete cells?

Right-click a cell, select Insert, and choose how to shift the cells.→Right-click a cell, select Delete, and choose what to remove.

53
New cards

What is the difference between Delete and deleting cells?

The Delete key clears contents. Deleting cells removes cells and can shift other cells.

54
New cards

How do you enter today's date? and how to format it?

Press Ctrl + ; (semicolon). Select the cell, click Home, open Number Format, and choose a date format.

55
New cards

What is a relative cell reference?

A reference that changes when copied, such as A1.

56
New cards

What is an absolute cell reference?

A reference that stays the same when copied, such as $A$1.

57
New cards

What is a mixed cell reference?

A reference that locks either the column or the row, such as $A1 (collum a is locked, row can change) or A$1.( a can change, row cannot)

58
New cards

What shortcut changes cell references?

F4.

59
New cards

What is the IF function used for?

Checking whether something is true or false.

60
New cards

format of an IF formula

=IF(condition,value_if_true,value_if_false)

61
New cards

What is a Sparkline? and how do you insert it.

A tiny chart inside one cell. → Click Insert, select Line, Column, or Win/Loss, choose the data range, and click OK.

62
New cards

What is Format Painter?

A tool that copies formatting from one cell to another.

63
New cards

What is a clustered column chart?

A chart that displays vertical columns grouped side by side.

64
New cards

How do you move a chart to its own sheet?

Select the chart, click Chart Design, choose Move Chart, select New Sheet, and click OK.

65
New cards

How do you use Chart Filters and what are they?

Tools that let you show or hide certain data in a chart. Click the chart, select the funnel icon, choose the data to display, and click Apply.

66
New cards

How do you reorder worksheet tabs?

Click and hold a sheet tab, drag it left or right, and release.

67
New cards

What is Normal view?

The regular worksheet view used to work with spreadsheet information.

68
New cards

What is Page Layout view?

Shows how the worksheet will look when printed.

69
New cards

What is Page Break Preview?

Shows where pages will break when printing.

70
New cards

. What does Freeze Panes do? how would you freeze the top row.

Keeps rows or columns visible while scrolling. → Click View, Freeze Panes, and Freeze Top Row.

71
New cards

. What is What-If Analysis? and where is it located

A tool that lets you change numbers to see how the results change. Under the Data tab.

72
New cards

What are the three What-If Analysis tools?

SM→ save a copared sets of numbers/scenerios

Goal seak→ finds number needed to reach result

data table→ changing one or two numbers effect formula