0% found this document useful (0 votes)
10 views1 page

Activity 2

The document provides detailed formatting instructions for creating a spreadsheet, including specific guidelines for font styles, sizes, colors, and cell merging. It outlines how to enter personal information, group details, and date formats, as well as how to protect and save the file. The final submission should include a specified filename and password for access.

Uploaded by

bombitamarissav
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views1 page

Activity 2

The document provides detailed formatting instructions for creating a spreadsheet, including specific guidelines for font styles, sizes, colors, and cell merging. It outlines how to enter personal information, group details, and date formats, as well as how to protect and save the file. The final submission should include a specified filename and password for access.

Uploaded by

bombitamarissav
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

• Enter your date of birth in this format (year-abbreviated

Margins: Narrow month name(day), day of week). For example, my birthday


Orientation: Portrait on April 11, 1996 would display like this 1996-Apr(11),
Size: A4 Thursday
Column Width of Column A: 1 F9 to L10
Row Height of Row 1: 9 • Merge Cells
B2 to D10 • Font Family: Franklin Gothic Heavy
• Merge Cells • Font Size: 20
• Border Presents: Outline • Font Color: Green
• Border Line Color: Red • Bold and Italic
• Font Family: Arial Black • Alignment (Text Alignment: Horizontal): Center
• Font Size: 20 • Alignment (Text Alignment: Vertical): Center
• Font Color: White • Alignment (Text Control): Shrink to Fit
• Fill Color: Black • Font Effect: Strikethrough
• Alignment (Text Orientation): 45 Degrees • Enter (CAPITAL LETTERS): ACTIVITY IS DONE
• Alignment (Text Alignment: Horizontal): Center B12 to L13
• Alignment (Text Alignment: Vertical): Center • Merge Cells
• Alignment (Text Control): Wrap text • Font Family: Franklin Gothic Demi
• Enter your group no. (Example: GROUP 1) • Font Size: 13
Column Width of Column E: 3 • Font Color: Black
Column Width of Column M: 1 • Bold, Italic and Underline
F2 to L4 • Alignment (Text Alignment: Horizontal): Center
• Merge Cells • Alignment (Text Alignment: Vertical): Bottom
• Border Presents: Outline • Alignment (Text Control): Wrap Text
• Border Line Color: Black • Enter (CAPITAL LETTERS): COMPUTER FOR BUSINESS
• Font Family: Franklin Gothic Heavy RECORDS
• Font Size: 20 B14 to L29
• Font Color: Red • Font Group: Borders: All Borders
• Underlined • B14 to L14, Enter No, Last Name, First Name, M.I.,
• Alignment (Text Alignment: Horizontal): Left (Indent) Attendance, Project, Recitation, Quiz, Major Exam,
• Alignment (Text Alignment: Vertical): Center Remarks, Date
• Alignment (Text Control): Wrap text o Font Size: 8
• Enter your full name (anyone in the group) in capital letters o Font Family: Arial Nova Cond Light, Bold
with format FN MI LN (Example: MARCELO H. DEL o Fill Color: Yellow
PILLAR) • B14 to L29 : Format as Table Style
F5 to L6 o Light Orange, Table Style Light 3
• Merge Cells o Uncheck my table has headers, ok
• Font Family: Franklin Gothic Medium o Uncheck Header Row in Table Design
• Font Size: 20 • Date Format (L16 to L30), enter current date&time [=now()]
• Font Color: Black o Resize column width to 12
• Bold • Input desired values B16 to K30
• Alignment (Text Alignment: Horizontal): Left (Indent) B35: PREPARED BY:
• Alignment (Text Alignment: Vertical): Center • Font Family: Tahoma
• Alignment (Text Control): Shrink to Fit • Font Size: 11
• Enter your complete address with proper casing and no B36 to B42: (ENTER GROUP MEMBERS)
abbreviations (Example: Calangcawan Norte, Vinzons, • Font Family: Tahoma
Camarines Norte) • Font Size: 11
F7 to L8 • Font Style: Bold
• Merge Cells A1 to M45: Border Presents: Outline
• Font Family: Franklin Gothic Medium
• Font Size: 20 Protect Sheet 1: Check all options and use password: enter your
• Font Color: Black desired password
• Fill Color: Orange Save using filename:
COURSE.SECTION_GROUPNO_ACTIVITY2
• Bold
Example:
• Alignment (Text Alignment: Horizontal): Left (Indent)
BSBAHRM.1A_GROUP1_ACTIVITY2
• Alignment (Text Alignment: Vertical): Center Submit the file in our groupchat, send the password to your
• Alignment (Text Control): Shrink to Fit instructor.

You might also like