Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Excel 2013 > Ch2 Headings > Flashcards

Ch2 Headings Flashcards

1
Q

How Many Worksheets can a WorkBook Hold

A

Excel workbooks can hold an unlimited amount of work sheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Numeric Values

A
  • Numeric values represent a quantity of some sort.
    • Examples: Sales amounts, numbers of employees, test scores, etc.
  • Dates and times can also used.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Text Entries

A
  • Text is used for data, labels for values, headings for columns.
  • Text is mostly used to clarify what the values of a worksheet may mean and where numbers come from.
  • Text that starts with a number is still considered to be text.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Formulas

A
  • Formulas use values in cells to calculate results.
  • If you enter a formula into a cell, the result of the formulas calculation will appear in the cel..
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Entering Text and Values into a Worksheet

A
  • To enter values in a cell, move the active cell indicator to the cell, enter the value and press enter.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What Happens if you enter a lot text in a cell

A
  • If you enter a lot of characters in a cell, they will not be displayed.
  • If the cell to the right of the one with a lot of text is empty, excel will display all of the text by making it look like the text flows into the empty cell.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How Excel Treats Dates and Times

A
  • Excel treats dates and times as a special type of numeric value.
  • They are formatted so that they appear as dates and times.
  • But they are treated as numeric strings.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How Excel Handles Dates

A
  • Excel handles dates by using a serial number system.
  • The earliest date that Excel understands is January 1, 1900.
  • This date has a serial number of 1.
  • January 2, 1900 has a serial number of 2.
  • If you enter a date, Excel will show it in proper date format and store the date in serial format.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How Serial Dates are Useful in Formulas

A

Using serial dates allows you to easily write them in formulas and do different things like compare how many days are between the dates.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How Excel Handles Times

A
  • Excel handles time in the same way that it handles dates, by using a serialized system.
  • The serialized system is extended to include decimials.
  • The decmials represent fractional days.
  • Example: June 1 2013 at 12:00 pm is 14126.5 (halfway through the day)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Deleting a Cells Contents

A
  • To delete the value in a cell, click on the cell and press the delete key.
  • To delete more than one cell, highlight the cells and press the delete key.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Using Clear to Delete Cell Contents

A
  • Clear offer more control when deleting items.
  • Clear is found in: Home - Editing - Clear
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Replacing Cell Contents

A
  • To replace cell contents, click on the cell and type in the new value.
  • You can also drag and drop or paste new content into the cell.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Editing the Contents of a Cell

A
  • Sometimes you may only want to edit a few characters in a cell.
  • To make the changes, you can entere cell ediitng mode.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Cell Editing with the Keyboard

A
  • While editing within a cell, you can use the keyboad to move around the cell.
  • The navigation keys can be used to move within the cell.
  • Pressing home moves the insertion point to the beginning of the cell.
  • Pressing end moves the insertion point to the end of the cell.
  • Select multiple characters by holding shift.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Enter the current date or time into a cell

A
  • To enter a date or time stamp into a worksheet:
    • Press Ctrl+; for current date.
    • Press Ctrl+Shift+; for current time.
  • These times will not update. If you want them to update, enter the following formulas:
    • =TODAY()
    • =NOW()
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Number Formatting

A
  • Refers to the process of changing the appearance of values contained in cells.
  • This formatting makes it easier to read an excel spreadsheet.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Apply Number Formatting with the Ribbon

A
  • Number formatting can be found under the Home - Number Group.
  • This allows you to quickly apply common formatting.
  • It contains 11 common number formats.
  • When the format is clicked on, it is applied to every cell that is selected.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Using Shortcut keys to Format Numbers

A
  • The following shortcut keys can be used to apply number formatting:
    • Ctrl - Shift - ~: General number format for unformatted values.
    • Ctrl - Shift - $: Currency format with two decmical places.
    • Ctrl - Shift - %: Percentage format.
    • Ctrl+Shift+^: Scientific notation.
    • Ctrl+Shift+#: Date Format with Day Month and Year.
    • Ctrl+Shift+@: Time format.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Formatting Numbers using the Format Cells Dialog Box

A
  • If you need more control over number formats, you can use the Format Cells dialog box.
  • To bring up the dialog box:
    • Home - Number and click the small dialog box icon.
    • HOme - Number, click the number format drop down list and choose more number formats.
    • Press Ctrl+1
    • Right click a cell and choose Format cells from the shortcut list.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Number Format Categories

A
  • General
  • Number
  • Currency
  • Accounting
  • Date
  • Time
  • Percentage
  • Fraction
  • Scientific
  • Text
  • Special
  • Custom
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

General Number Format

A

The default format; it displays numbers as integers, as decimals, or in scientific notation if the value is too wide to fit in the cell.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Excel 2013 Number Format

A

Enables you to specify the number of decimal places, whether to use a comma to separate thousands, and how to display negative numbers (with a minus sign, in red, in parentheses, or in red and in parentheses).

24
Q

Currency Format

A

: Enables you to specify the number of decimal places, choose a currency symbol, and how to display negative numbers (with a minus sign, in red, in parentheses, or in red and in parentheses). This format always uses a comma to separate thousands.

25
Q

Accounting Format

A

Differs from the Currency format in that the currency symbols always align vertically.

26
Q

Date Number Format

A

: Enables you to choose from several different date formats.

27
Q

Time Format

A

Enables you to choose from several different time formats.

28
Q

Percentage Format

A

: Enables you to choose the number of decimal places and always displays a percent sign.

29
Q

Fraction Format

A

Enables you to choose from among nine fraction formats.

30
Q

Scientific Format

A

Displays numbers in exponential notation (with an E): 2.00E+05 = 200,000; 2.05E+05 = 205,000. You can choose the number of decimal places to display to the left of E. The second example can be read as “2.05 times 10 to the fifth.”

31
Q

Text Format

A

When applied to a value, causes Excel to treat the value as text (even if it looks like a number). This feature is useful for such items as part numbers and credit card numbers.

32
Q

Special Format

A

Contains additional number formats. In the U.S. version of Excel, the additional number formats are Zip Code, Zip Code +4, Phone Number, and Social Security Number.

33
Q

Custom Format

A

: Enables you to define custom number formats that aren’t included in any other category.

34
Q

What types of Data can an Excel Worksheet handle

A

Excel worksheets can handle text, numbers, formauls, images and objects

35
Q

What type of data can a cell hold?

A

Text

36
Q

What types of text data can a cell hold?

A
  • Numeric Values
  • Text
  • Formulas
37
Q

What types of data does the draw layer handle?

A

The draw layer handles charts, pictures and objects.

38
Q
A
39
Q

What types of symbols can be entered in a cell, along with text.

A
  • Decimal Points
  • Currency Symbols
  • Plus and Minus Signs
  • Commas (Separate thousads)
  • If you enclose a value in parathesis or a minus sign, Excel will consider the number to be a negative number.
40
Q

How do you show all of the characters in a cell if some are hidden?

A
  • To have all of the characters show, you can wrap the text so that it appears on a new line.
    • Wrapping Text: Choose Home - Alignment - Wrap Text
41
Q

Clear Command Sub Options

A
  • Clear has several sub options:
    • Clear All: Clears everything, including formatting and formulas.
    • Clear Formats; Clears only the formatting and leaves the value, text or formula.
    • Clear Contents: Clears only the cell’s contents and leaves the formatting.
    • Clear Comments; Clears a comment attached to the cell.
    • Clear Hyperlinks: Removes hyperlinks contained in a cell.
42
Q

Ways to put excel in cell editing mode

A
  • There are three ways to do this:
    • Double click on the cell.
    • Select the cell and press F2.
    • Select the cell and press in the formula bar.
  • These methods cause Excel to go into editing mode. The word edit appears in the botom right hand corner.
  • The formula bar also gains a check mark and an X.
43
Q

Default behavior of the cell pointer after hitting enter

A

By default, when you hit enter, the cell pointer moves down.

44
Q

Change the default behavior of the cell pointer after hitting enter.

A

To change this, go to File - OPtions and click the advanced tab. Click on the check box : After Pressing Enter Move Selection.

45
Q

Where does the cell pointer move if a range of cells are selected? What if multiple rows are selected?

A

When a range of cells is selected, Excel automatically moves the cell pointer to the next cell in the range when you press Enter. If the selection consists of multiple rows, Excel moves down the column; when it reaches the end of the selection in the column, it moves to the first selected cell in the next column

46
Q

How do you skip a cell?

A

To skip a cell, just press Enter without entering anything.

47
Q

How do you move the cell indicator backwards?

A

Press Shift+Enter

48
Q

Keyboard shortcut for entering data by rows, rather than columns?

A

Press tab.

49
Q

Set up excel to automatically enter decimal points.

A

Decimal points can be entered automatically by going to Excel Options, click the Advanced Tab and select “Automatically Insert a Decimal Point check box.:

50
Q

Force text to start on a new line in a cell.

A

Text can be forced to start on a new line by pressing Alt+Enter. Excel will automatically switch the cells format to Wrap Text.

51
Q

How to enter fractions.

A

To enter fractions, leave a space between the whole number and fraction. Example 6 7/8.

52
Q

What does excel provide for entering data quickly?

A
  • Excel provides a simple data entry form for entering data in lists that are arranged in rows.
  • The data form works with either a normal range of data or a range that has been designated as a table.
53
Q

How to setup the data form if it is not activate in Excel.

A
  • The form is not readily available and needs to be added to the quick access toolbar:
    • Right click the quick access toolbar and choose customize quick access toolbar.
    • In Choose Commands From Drop Down List windown, choose commands not in the ribbon.
    • In the list box, select form.
    • Click the add button to the add the selected command to the Quick Access toolbar.
54
Q

How to Access a Form to Enter Data In Excel

A
  • Arrange your data so that Excel can recognize it as a table by entering headings in the first row of the data entry range.
  • Select any cell in the table and click the form button on the Quick Access Toolbar.
  • Fill in the information and press the tab to move between the boxes.
  • When you complete the form, click the New Button.Enter the current date or time into a cell
55
Q
A

Excel 2013 (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions