Knowledge Assessment
Multiple Choice
Select the best response for the following statements.
1. You want to insert a cell into your worksheet. Which command do you use?
a. The Insert command in the Cells group on the HOME tab
b. The Format command in the Cells group on the HOME tab
c. The Format Painter command in the Clipboard group on the HOME tab
d. The Format command in the shortcut menu when you right-click a cell
2. You want to format a cell so the text is spread evenly throughout the cell, wrapping
Automatically and adjusting the row height, if necessary. Which alignment option do
You choose?
a. Center
b. Middle Align
c. Justify
d. Distributed
3. You want to fit a long column heading into a small space without changing the font size
Or
…show more content…
column width. Which of the following is the best choice? a. Adjust text orientation. b. Use the Center alignment command. c. Use the Merge & Center command. d. Apply a special character attribute. 4. How do you display the Mini toolbar? a. Left-click a cell. b. Right-click a cell. c. Select Format > Mini toolbar. d. Select View > Mini toolbar. 5. Which of the following can you not copy using Format Painter? a. Font color b. Bold c. Font size d. Cell content 6. Which Paste Special option pastes only the result of a formula rather than the formula? Itself? a. Formulas b. Values c. Formats d. Formulas and number formats 7. You don’t like the cell style you just applied. Which of the following is the least effective Way to remove or replace the style? a. Apply another style to the cell. b. Use the Undo command. c. Clear the cell’s content. d. Apply the Normal style to the cell. 8. How do you remove a hyperlink? a. Delete the cell. b. Edit the cell’s style. c. Reformat the cell. d. Right-click the cell and select Remove Hyperlink. 9. In which group on the HOME tab is the Clear Formats command located? A. In the Editing group B. In the Clipboard group C. In the Font group D. In the Cells group 10.
Which of the following is not useful for changing the font size?
A. Font Size drop-down list
B. Increase Font Size button
C. Decrease Font Size button
d. Orientation button
True / False
Circle T if the statement is true or F if the statement is false.
T F 1. When you delete cells in a worksheet, you remove one or more cells, forcing
Other cells to move down or to the right.
T F 2. When selecting a font color, you can choose a themed color but not a standard
Color from the palette.
T F 3. When you point to defined styles in the Cell Styles gallery, you can see the
Formatting that will be used when you apply each style.
T F 4. Underlining a cell’s content is the same as adding a border.
T F 5. You can apply multiple conditional formatting criteria or rules to the same set of
Data.
T F 6. Deleting a cell is the same as clearing a cell’s content.
T F 7. A hyperlink enables you to navigate to a web page, another file, or to a specific
Location in another file.
T F 8. Style attributes include fonts and font sizes, number formats, and borders and
Shading.
T F 9. You cannot split a single worksheet cell that has not been merged.
T F 10. After you select a color and apply it to a cell’s background, the Fill Color button
Takes on that
color.
Text Box: Table 2. Humerus length and height of female student in the classText Box: Table 1. Humerus length and height of male student in the class
3. Be careful with run-on sentences. Allow only one or two ideas in each sentence.
[IMAGE]I will assign a letter to the first number in the 2 x 2 square,
- Compare how this is achieved in your prescribed text and ONE other related text of your own choosing.
I found that in grid 5x5 that the formula for the added value of the
On the internet I was able to find out the numbers of red and yellow
Typography is a vital part of graphic design, and the expansion of this field has provided current artists with almost limitless possibilities. Researching type styles is important because it adds diversity to a graphic artist’s work, and it may possibly provide inspiration for creating one’s own font designs. There are many type designers, both past and present, who have had a great impact on the field and who are worthy of studying. One of those designers is Matthew Carter. Matthew Carter, born in 1937 in England, has typography in his blood.
start off with numbers and label them what the topic of the paragraph is going to be about. After I
As you move the mouse cursor to the palette, the mouse pointer changes to the Color Selection Tool's pointer. When you find a color you like, simply click on it to make it the active color.
Name: Change the labels adapted in the first row of Excel file into new variable names (regard the variables background of the conceptual framework, must be short, no space), as indicated in the below table.
This is when you have a target cell that you want a specific value in.
Rules. Establish ground rules that everyone must abide by, such as no hitting, name-calling, teasing, or damaging one another’s property. Allow them the chance to voice their opinion on how these rules will be established and enforced. Dan Brennan, MD, suggests letting the children take part in the decision-making process gives them a sense of competence, letting them feel as if they have control over their own lives. (WebMD) We had rules in our home. We knew what they were, why they were there, and what would happen if we disobeyed those rules. This tip was invaluable to my parents, and any other parents, in my opinion.
Print or type using a 12 point standard font, such as Times, Geneva, Bookman, Helvetica, etc.
o Modern crisp fonts have been used in the main body of the text so
The font was also changed for each heading. This was done by highlighting the certain headings or tasks that needs to be edited and changing the font to whatever style/size is needed.